<?php

namespace app\admin\controller\supplier;

use app\common\controller\Backend;
use app\common\model\supplier\Brands;
use think\Db;
use app\common\controller\Extend;

/**
 * 
 *
 * @icon fa fa-circle-o
 */
class Supplier extends Backend
{
    
    /**
     * Supplier模型对象
     * @var \app\common\model\supplier\Supplier
     */
    protected $model = null;
    protected $searchFields = 'id,nickname';
    public function _initialize()
    {
        parent::_initialize();
        $this->model = new \app\common\model\supplier\Supplier;
//        $citys = Db::name('area')->where(array('pid'=>0))->select();
//        $this->assign('citys',$citys);
    }
    
    /**
     * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
     * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
     * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
     */
    

    /**
     * 查看
     */
    public function index()
    {
        //当前是否为关联查询
        $this->relationSearch = true;
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax())
        {
            //如果发送的来源是Selectpage，则转发到Selectpage
            if ($this->request->request('keyField'))
            {
                return $this->selectpage();
            }
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
            $total = $this->model
                    ->with(['area'])
                    ->where($where)
                    ->order($sort, $order)
                    ->count();

            $list = $this->model
                    ->with(['area'])
                    ->where($where)
                    ->order($sort, $order)
                    ->limit($offset, $limit)
                    ->select();

            foreach ($list as $row) {
                $row->visible(['id','nickname','remark','contacts','mobile','createtime','tel','is_inside']);
                $row->visible(['area']);
				$row->getRelation('area')->visible(['name']);
            }
            $list = collection($list)->toArray();
            $result = array("total" => $total, "rows" => $list);

            return json($result);
        }
        return $this->view->fetch();
    }
    public function add(){
        if ($this->request->isAjax())
        {
            $params = input('');
            $data = $params['row'];
            $res =$this->model->save($data);
            if($res){
                $this->success('添加成功');
            }else{
                $this->error('添加失败');
            }
        }

        return $this->view->fetch();
    }
    public function import()
    {

       $Extend = new Extend;
       $currSheet = $Extend->getdata('file');
       foreach ($currSheet as $k=> $v){
           if($k <15){
               continue;
           }
           $data[] = array(
             'nickname'=>$v[3],
             'remark'=>$v[5],
             'contacts'=>$v[6],
             'mobile'=>$v[7],
           );
       }
       $this->model->saveAll($data);
       $this->success('导入成功');
    }
    public function change($ids){
        $row = $this->model->find($ids);
        if($row){
            if($row['is_inside'] == 1){
                $data = array(
                    'is_inside'=>0,
                );
            }else{
                $data = array(
                    'is_inside'=>1,
                );
            }
            $res = $this->model->save($data,array('id'=>$ids));
            if($res){
                $this->success('设置成功');
            }
        }
        $this->error('异常');
    }
}
